﻿namespace JxcLite.Repositories;

class InventoryRepository
{
    internal static Task<PagingResult<InventoryInfo>> QueryInventoriesAsync(Database db, PagingCriteria criteria)
    {
        var sql = @"select a.* 
     ,0 as ImportQty
     ,0 as ImportReturnQty
     ,0 as ExportQty
     ,0 as ExportReturnQty
     ,0 as InventoryQty
from JxGoods a 
where a.CompNo=@CompNo";
        return db.QueryPageAsync<InventoryInfo>(sql, criteria);
    }
}